// Copyright (C) 2008 Google Inc.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//      http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.



/**
 * @fileoverview
 * Registers a language handler for T-SQL.
 * http://google-code-prettify.googlecode.com/svn/trunk/src/lang-sql.js as the basis
 * for the sript.
 *
 * To use, include prettify.js (http://google-code-prettify.googlecode.com/svn/trunk/src/prettify.js)
 * , prettify.css (http://google-code-prettify.googlecode.com/svn/trunk/src/prettify.css)
 * , prettify-tsql.css (http://blogspot-file-storage.googlecode.com/svn/trunk/CSS/prettify-tsql.css)
 * and this file (http://blogspot-file-storage.googlecode.com/svn/trunk/Scripts/lang-tsql.js)
 * into your HTML page.
 * 
 * Then put your code in an HTML tag like
 *      <pre class="tsql prettyprint lang-tsql">(my SQL code)</pre>
 *
 *
 * http://savage.net.au/SQL/sql-99.bnf.html is the basis for the grammar, and
 * http://msdn.microsoft.com/en-us/library/ms189822.aspx as the basis for the keyword list.
 *
 * @author spiritusscientiae@gmail.com
 */
var PR_FUN = 'fun';
var PR_SYS = 'sys';
var PR_PROC = 'proc';
PR['registerLangHandler'](
    PR['createSimpleLexer'](
        [
         // Whitespace
         [PR['PR_PLAIN'],       /^[\t\n\r \xA0]+/, null, '\t\n\r \xA0'],
         // A double or single quoted, possibly multi-line, string.
         [PR['PR_STRING'],      /^(?:"(?:[^\"\\]|\\.)*"|'(?:[^\'\\]|\\.)*')/, null,'"\'']
        ],
        [
         // A comment is either a line comment that starts with two dashes, or
         // two dashes preceding a long bracketed block.
         [PR['PR_COMMENT'], /^(?:--[^\r\n]*|\/\*[\s\S]*?(?:\*\/|$))/],
         [PR['PR_KEYWORD'], /^(?:ADD|ALL|ALTER|AND|ANY|AS|ASC|AUTHORIZATION|BACKUP|BEGIN|BETWEEN|BREAK|BROWSE|BULK|BY|CASCADE|CASE|CHECK|CHECKPOINT|CLOSE|CLUSTERED|COLLATE|COLUMN|COMMIT|COMPUTE|CONSTRAINT|CONTAINS|CONTAINSTABLE|CONTINUE|CREATE|CROSS|CURRENT|CURRENT_DATE|CURRENT_TIME|CURRENT_TIMESTAMP|CURRENT_USER|CURSOR|DATABASE|DBCC|DEALLOCATE|DECLARE|DEFAULT|DELETE|DENY|DESC|DISK|DISTINCT|DISTRIBUTED|DOUBLE|DROP|DUMMY|DUMP|ELSE|END|ERRLVL|ESCAPE|EXCEPT|EXEC|EXECUTE|EXISTS|EXIT|FETCH|FILE|FILLFACTOR|FOR|FOREIGN|FREETEXT|FREETEXTTABLE|FROM|FULL|FUNCTION|GOTO|GRANT|GROUP|HAVING|HOLDLOCK|IDENTITY|IDENTITYCOL|IDENTITY_INSERT|IF|IN|INDEX|INNER|INSERT|INTERSECT|INTO|IS|JOIN|KEY|KILL|LEFT|LIKE|LINENO|LOAD|MATCH|MERGE|NATIONAL|NOCHECK|NONCLUSTERED|NOT|NULLIF|OF|OFF|OFFSETS|ON|OPEN|OPENDATASOURCE|OPENQUERY|OPENROWSET|OPENXML|OPTION|OR|ORDER|OUTER|OVER|PERCENT|PLAN|PRECISION|PRIMARY|PRINT|PROC|PROCEDURE|PUBLIC|RAISERROR|READ|READTEXT|RECONFIGURE|REFERENCES|REPLICATION|RESTORE|RESTRICT|RETURN(S)?|REVOKE|RIGHT|ROLLBACK|ROWCOUNT|ROWGUIDCOL|RULE|SAVE|SCHEMA|SELECT|SESSION_USER|SET|SETUSER|SHUTDOWN|SOME|STATISTICS|SYSTEM_USER|TABLE|TEXTSIZE|THEN|TO|TOP|TRAN|TRANSACTION|TRIGGER|TRUNCATE|TSEQUAL|UNION|UNIQUE|UPDATE|UPDATETEXT|USE|USER|USING|VALUES|VARYING|VIEW|WAITFOR|WHEN|WHERE|WHILE|WITH|WRITETEXT)(?=[^\w-]|$)/i, null],
         [PR['PR_KEYWORD'], /^(?:GO|DATE(FIRST|FORMAT)|LANGUAGE)(?=[^\w-]|$)/i, null],
         //Date and Time Functions
         [PR_FUN, /^(?:GET(UTC)?DATE|DATE(ADD|DIFF|NAME|PART)|(GET|IS)DATE|(DAY|MONTH|EOMONTH|YEAR)(?=(?:\s*))|CURRENT_TIMESTAMP|(DATE|TIME|DATETIME|DATETIME2|DATETIMEOFFSET|SMALLDATETIME)FROMPARTS|(SWITCH|TODATETIME)OFFSET|@@DATEFIRST|@@LANGUAGE)(?=[^\w-]|$)/i, null],
         //A date part constant
         [PR['PR_KEYWORD'], /^(?:DAY|DAYOFYEAR|HOUR|MICROSECOND|MILLISECOND|MINUTE|MONTH|NANOSECOND|QUARTER|SECOND|WEEK|WEEKDAY|YEAR)(?=[^\w-]|$)/i, null],
         [PR_FUN, /^(?:MAX|MIN|AVG|COALESCE|OBJECT_ID|CAST|CONVERT)(?=[^\w-]|$)/i, null],
         [PR_SYS, /^(?:(sys\.)[\w]+|(fn_)[\w]+|(information_schema\.)[\w]+)(?=[^\w-]|$)/i, null],
         [PR_PROC, /^(?:(sp_)[\w]+)(?=[^\w-]|$)/i, null],
         //An SQL type
         [PR['PR_TYPE'], /^(?:(BIG|TIN|SMALL)?INT|NUMERIC|BIT|DECIMAL|(SMALL)?MONEY|FLOAT|REAL|DATE(TIMEOFFSET)?|(SMALL)?DATETIME(2)?|TIME(STAMP)?|(VAR|NVAR|N)?CHAR|(N)?TEXT|NTEXT|(VAR)?BINARY|IMAGE|CURSOR|HIERARCHYID|UNIQUEIDENTIFIER|SQL_VARIANT|XML|TABLE)(?=[^\w-]|$)/i, null],
         // A number is a hex integer literal, a decimal real literal, or in scientific notation.
         [PR['PR_LITERAL'], /^[+-]?(?:0x[\da-f]+|(?:(?:\.\d+|\d+(?:\.\d*)?)(?:e[+\-]?\d+)?)|(NULL)+)/i],
         // An identifier
         [PR['PR_PLAIN'], /^[a-z_][\w-]*/i],
         // A run of punctuation
         [PR['PR_PUNCTUATION'], /^[^\w\t\n\r \xA0\"\'][^\w\t\n\r \xA0+\-\"\']*/]
        ]),
    ['tsql']);
